import sqlite3

with sqlite3.connect("idle.db") as conn:
    cursor=conn.cursor()
    sql1='''CREATE TABLE if not exists idle(id integer primary key,
    name text not null,
    age integer not null,
    height integer not null,
    photo blob)'''
    idle_information=[
        ("soyeon",26,157),
        ("yuqi",25,163),
        ("miyeon",28,161),
        ("minnie",27,167),
        ("shuhua",25,161)
    ]
    cursor.execute(sql1)
    cursor.executemany("INSERT INTO idle(name,age,height)values(?,?,?)",idle_information)
    cursor.execute("SELECT *FROM idle ORDER BY height DESC")
    for i in cursor.fetchall():
        print(i[0],i[1],i[3])
